Access2Web 1.2 comes with new data formatting features. This way you can display your data in various ways on your HTML pages.

This format parameter works like this:

Formatting Time data type:
format(Long Time) displays 5:34:23 PM, system-defined long time format
format(Medium time) displays 5:34 PM, system-defined medium time format
format(Short time) displays 5:34, system-defined short time format
format(h:m:s) displays 17:4:23
format(hh:mm:ss) displays 05:04:23 PM


Formatting Date data type:
format(Long Date) displays Sunday, June 19, 1994, system-defined long date format
format(Medium Date) displays 19-Jun-94, system-defined medium date format
format(Short Date) displays 19-06-94, system-defined short date format
format(dddd, mmm d yyyy) displays Sunday, Jun 19 1994
format(dd mm yy) displays 19-06-99


Formatting Number data type (#=optonal, 0=required):
format(##,##0.00) displays 5,459.00 or 0.12
format(##0.00) displays 5459.00 or 0.12
format(0.00%) displays 125.00%


Formatting Text type:
format(>) displays MyText in uppercase "HELLO"
format(<) displays MyText in lowercase "hello"

By Paul Mortensen, 25. september 1999